By executing this extended SQL statement, CONNX disallows passthrough of a SQL statement to SQL Server.

 

Example:

SELECT * FROM customers {nopassthrough}

 

To use the DBKEY value for subsequent queries in Rdb databases, use the above defined CONNX SQL extended function "{nopassthrough}" on all queries that reference the DBKEY, or you may receive or transmit the passthrough type DBKEY (which is binary in format). In general, it is easier to manipulate DBKEY values in character mode.

 

To use the Oid value for subsequent queries in PostgreSQL databases, use the above defined CONNX SQL extended function "{nopassthrough}" on all queries that reference the Oid, or you may receive or transmit the passthrough type Oid (which is binary in format).  In general, it is easier to manipulate Oid values in character mode.